Sitecore 5.3 and Oracle XE

Author: Andrei Komarov
Posted: 7/9/2007 1:27:35 PM

Question: How I can install Sitecore 5.3 on Oracle XE.

Solution: The installation procedure is similar to the standard Oracle based installation.

Difference: Oracle XE has one database the XE and you cannot change it.

Therefore, when you install default Sitecore databases (or transferring data from MS SQL to appropriate schemas) you need to specify XE as an Oracle database.

Also, you need to skip step 2 “Create new Oracle database instance.” from the section “3.1. Preparing the Server”.

Example:

Installing Default Sitecore Databases

For creating and populating schemas for Sitecore it is necessary to execute the createdata.bat file in the /install folder. The file is launched with the following parameters: createdata.bat[DATABASE] [PASSWORD] [PREFIX]

createdata.bat supports the following environment variables and command line parameters:

DATABASE	TNS Service name to access Oracle: XE
PASSWORD	Password for system user in the database (default: manager)
ORACLE_DATA_DIR	Path to Oracle data storage folder (default: D:\Oraclexe\oradata). The script will create the tablespace data file in %ORACLE_DATA_DIR%\%DATABASE% folder.
PREFIX	Prefix for schemas (default: sc) It is possible to install multiple instances of Sitecore onto a single Oracle database by setting different prefixes during import.

For example: createdata.bat XE [PASSWORD] [PREFIX]

Prev Next